package com.test.test_rest.blockchain_data.domain.gen;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TranGridDataCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer mysqlOffset;

    protected Integer mysqlLength;

    protected String isCURD;

    public TranGridDataCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlOffset(Integer mysqlOffset) {
        this.mysqlOffset=mysqlOffset;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlOffset() {
        return mysqlOffset;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlLength(Integer mysqlLength) {
        this.mysqlLength=mysqlLength;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlLength() {
        return mysqlLength;
    }

    public void setIsCURD(String isCURD) {
        this.isCURD=isCURD;
    }

    public String getIsCURD() {
        return isCURD;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andJobIdIsNull() {
            addCriterion("JOB_ID is null");
            return (Criteria) this;
        }

        public Criteria andJobIdIsNotNull() {
            addCriterion("JOB_ID is not null");
            return (Criteria) this;
        }

        public Criteria andJobIdEqualTo(Integer value) {
            addCriterion("JOB_ID =", value, "jobId");
            return (Criteria) this;
        }

        public Criteria andJobIdNotEqualTo(Integer value) {
            addCriterion("JOB_ID <>", value, "jobId");
            return (Criteria) this;
        }

        public Criteria andJobIdGreaterThan(Integer value) {
            addCriterion("JOB_ID >", value, "jobId");
            return (Criteria) this;
        }

        public Criteria andJobIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("JOB_ID >=", value, "jobId");
            return (Criteria) this;
        }

        public Criteria andJobIdLessThan(Integer value) {
            addCriterion("JOB_ID <", value, "jobId");
            return (Criteria) this;
        }

        public Criteria andJobIdLessThanOrEqualTo(Integer value) {
            addCriterion("JOB_ID <=", value, "jobId");
            return (Criteria) this;
        }

        public Criteria andJobIdIn(List<Integer> values) {
            addCriterion("JOB_ID in", values, "jobId");
            return (Criteria) this;
        }

        public Criteria andJobIdNotIn(List<Integer> values) {
            addCriterion("JOB_ID not in", values, "jobId");
            return (Criteria) this;
        }

        public Criteria andJobIdBetween(Integer value1, Integer value2) {
            addCriterion("JOB_ID between", value1, value2, "jobId");
            return (Criteria) this;
        }

        public Criteria andJobIdNotBetween(Integer value1, Integer value2) {
            addCriterion("JOB_ID not between", value1, value2, "jobId");
            return (Criteria) this;
        }

        public Criteria andSymbolIsNull() {
            addCriterion("SYMBOL is null");
            return (Criteria) this;
        }

        public Criteria andSymbolIsNotNull() {
            addCriterion("SYMBOL is not null");
            return (Criteria) this;
        }

        public Criteria andSymbolEqualTo(String value) {
            addCriterion("SYMBOL =", value, "symbol");
            return (Criteria) this;
        }

        public Criteria andSymbolNotEqualTo(String value) {
            addCriterion("SYMBOL <>", value, "symbol");
            return (Criteria) this;
        }

        public Criteria andSymbolGreaterThan(String value) {
            addCriterion("SYMBOL >", value, "symbol");
            return (Criteria) this;
        }

        public Criteria andSymbolGreaterThanOrEqualTo(String value) {
            addCriterion("SYMBOL >=", value, "symbol");
            return (Criteria) this;
        }

        public Criteria andSymbolLessThan(String value) {
            addCriterion("SYMBOL <", value, "symbol");
            return (Criteria) this;
        }

        public Criteria andSymbolLessThanOrEqualTo(String value) {
            addCriterion("SYMBOL <=", value, "symbol");
            return (Criteria) this;
        }

        public Criteria andSymbolLike(String value) {
            addCriterion("SYMBOL like", value, "symbol");
            return (Criteria) this;
        }

        public Criteria andSymbolNotLike(String value) {
            addCriterion("SYMBOL not like", value, "symbol");
            return (Criteria) this;
        }

        public Criteria andSymbolIn(List<String> values) {
            addCriterion("SYMBOL in", values, "symbol");
            return (Criteria) this;
        }

        public Criteria andSymbolNotIn(List<String> values) {
            addCriterion("SYMBOL not in", values, "symbol");
            return (Criteria) this;
        }

        public Criteria andSymbolBetween(String value1, String value2) {
            addCriterion("SYMBOL between", value1, value2, "symbol");
            return (Criteria) this;
        }

        public Criteria andSymbolNotBetween(String value1, String value2) {
            addCriterion("SYMBOL not between", value1, value2, "symbol");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("PRICE is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(BigDecimal value) {
            addCriterion("PRICE =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(BigDecimal value) {
            addCriterion("PRICE <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(BigDecimal value) {
            addCriterion("PRICE >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PRICE >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(BigDecimal value) {
            addCriterion("PRICE <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PRICE <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<BigDecimal> values) {
            addCriterion("PRICE in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<BigDecimal> values) {
            addCriterion("PRICE not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PRICE between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PRICE not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andSumNumIsNull() {
            addCriterion("SUM_NUM is null");
            return (Criteria) this;
        }

        public Criteria andSumNumIsNotNull() {
            addCriterion("SUM_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andSumNumEqualTo(BigDecimal value) {
            addCriterion("SUM_NUM =", value, "sumNum");
            return (Criteria) this;
        }

        public Criteria andSumNumNotEqualTo(BigDecimal value) {
            addCriterion("SUM_NUM <>", value, "sumNum");
            return (Criteria) this;
        }

        public Criteria andSumNumGreaterThan(BigDecimal value) {
            addCriterion("SUM_NUM >", value, "sumNum");
            return (Criteria) this;
        }

        public Criteria andSumNumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SUM_NUM >=", value, "sumNum");
            return (Criteria) this;
        }

        public Criteria andSumNumLessThan(BigDecimal value) {
            addCriterion("SUM_NUM <", value, "sumNum");
            return (Criteria) this;
        }

        public Criteria andSumNumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SUM_NUM <=", value, "sumNum");
            return (Criteria) this;
        }

        public Criteria andSumNumIn(List<BigDecimal> values) {
            addCriterion("SUM_NUM in", values, "sumNum");
            return (Criteria) this;
        }

        public Criteria andSumNumNotIn(List<BigDecimal> values) {
            addCriterion("SUM_NUM not in", values, "sumNum");
            return (Criteria) this;
        }

        public Criteria andSumNumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SUM_NUM between", value1, value2, "sumNum");
            return (Criteria) this;
        }

        public Criteria andSumNumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SUM_NUM not between", value1, value2, "sumNum");
            return (Criteria) this;
        }

        public Criteria andSumUsdtIsNull() {
            addCriterion("SUM_USDT is null");
            return (Criteria) this;
        }

        public Criteria andSumUsdtIsNotNull() {
            addCriterion("SUM_USDT is not null");
            return (Criteria) this;
        }

        public Criteria andSumUsdtEqualTo(BigDecimal value) {
            addCriterion("SUM_USDT =", value, "sumUsdt");
            return (Criteria) this;
        }

        public Criteria andSumUsdtNotEqualTo(BigDecimal value) {
            addCriterion("SUM_USDT <>", value, "sumUsdt");
            return (Criteria) this;
        }

        public Criteria andSumUsdtGreaterThan(BigDecimal value) {
            addCriterion("SUM_USDT >", value, "sumUsdt");
            return (Criteria) this;
        }

        public Criteria andSumUsdtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SUM_USDT >=", value, "sumUsdt");
            return (Criteria) this;
        }

        public Criteria andSumUsdtLessThan(BigDecimal value) {
            addCriterion("SUM_USDT <", value, "sumUsdt");
            return (Criteria) this;
        }

        public Criteria andSumUsdtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SUM_USDT <=", value, "sumUsdt");
            return (Criteria) this;
        }

        public Criteria andSumUsdtIn(List<BigDecimal> values) {
            addCriterion("SUM_USDT in", values, "sumUsdt");
            return (Criteria) this;
        }

        public Criteria andSumUsdtNotIn(List<BigDecimal> values) {
            addCriterion("SUM_USDT not in", values, "sumUsdt");
            return (Criteria) this;
        }

        public Criteria andSumUsdtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SUM_USDT between", value1, value2, "sumUsdt");
            return (Criteria) this;
        }

        public Criteria andSumUsdtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SUM_USDT not between", value1, value2, "sumUsdt");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("STATUS =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("STATUS <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("STATUS >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("STATUS >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("STATUS <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("STATUS <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("STATUS like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("STATUS not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("STATUS in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("STATUS not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("STATUS between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("STATUS not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andCoverTypeIsNull() {
            addCriterion("COVER_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andCoverTypeIsNotNull() {
            addCriterion("COVER_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCoverTypeEqualTo(Integer value) {
            addCriterion("COVER_TYPE =", value, "coverType");
            return (Criteria) this;
        }

        public Criteria andCoverTypeNotEqualTo(Integer value) {
            addCriterion("COVER_TYPE <>", value, "coverType");
            return (Criteria) this;
        }

        public Criteria andCoverTypeGreaterThan(Integer value) {
            addCriterion("COVER_TYPE >", value, "coverType");
            return (Criteria) this;
        }

        public Criteria andCoverTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("COVER_TYPE >=", value, "coverType");
            return (Criteria) this;
        }

        public Criteria andCoverTypeLessThan(Integer value) {
            addCriterion("COVER_TYPE <", value, "coverType");
            return (Criteria) this;
        }

        public Criteria andCoverTypeLessThanOrEqualTo(Integer value) {
            addCriterion("COVER_TYPE <=", value, "coverType");
            return (Criteria) this;
        }

        public Criteria andCoverTypeIn(List<Integer> values) {
            addCriterion("COVER_TYPE in", values, "coverType");
            return (Criteria) this;
        }

        public Criteria andCoverTypeNotIn(List<Integer> values) {
            addCriterion("COVER_TYPE not in", values, "coverType");
            return (Criteria) this;
        }

        public Criteria andCoverTypeBetween(Integer value1, Integer value2) {
            addCriterion("COVER_TYPE between", value1, value2, "coverType");
            return (Criteria) this;
        }

        public Criteria andCoverTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("COVER_TYPE not between", value1, value2, "coverType");
            return (Criteria) this;
        }

        public Criteria andCoverPercentIsNull() {
            addCriterion("COVER_PERCENT is null");
            return (Criteria) this;
        }

        public Criteria andCoverPercentIsNotNull() {
            addCriterion("COVER_PERCENT is not null");
            return (Criteria) this;
        }

        public Criteria andCoverPercentEqualTo(BigDecimal value) {
            addCriterion("COVER_PERCENT =", value, "coverPercent");
            return (Criteria) this;
        }

        public Criteria andCoverPercentNotEqualTo(BigDecimal value) {
            addCriterion("COVER_PERCENT <>", value, "coverPercent");
            return (Criteria) this;
        }

        public Criteria andCoverPercentGreaterThan(BigDecimal value) {
            addCriterion("COVER_PERCENT >", value, "coverPercent");
            return (Criteria) this;
        }

        public Criteria andCoverPercentGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("COVER_PERCENT >=", value, "coverPercent");
            return (Criteria) this;
        }

        public Criteria andCoverPercentLessThan(BigDecimal value) {
            addCriterion("COVER_PERCENT <", value, "coverPercent");
            return (Criteria) this;
        }

        public Criteria andCoverPercentLessThanOrEqualTo(BigDecimal value) {
            addCriterion("COVER_PERCENT <=", value, "coverPercent");
            return (Criteria) this;
        }

        public Criteria andCoverPercentIn(List<BigDecimal> values) {
            addCriterion("COVER_PERCENT in", values, "coverPercent");
            return (Criteria) this;
        }

        public Criteria andCoverPercentNotIn(List<BigDecimal> values) {
            addCriterion("COVER_PERCENT not in", values, "coverPercent");
            return (Criteria) this;
        }

        public Criteria andCoverPercentBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("COVER_PERCENT between", value1, value2, "coverPercent");
            return (Criteria) this;
        }

        public Criteria andCoverPercentNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("COVER_PERCENT not between", value1, value2, "coverPercent");
            return (Criteria) this;
        }

        public Criteria andTaskIdIsNull() {
            addCriterion("TASK_ID is null");
            return (Criteria) this;
        }

        public Criteria andTaskIdIsNotNull() {
            addCriterion("TASK_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTaskIdEqualTo(Integer value) {
            addCriterion("TASK_ID =", value, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdNotEqualTo(Integer value) {
            addCriterion("TASK_ID <>", value, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdGreaterThan(Integer value) {
            addCriterion("TASK_ID >", value, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("TASK_ID >=", value, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdLessThan(Integer value) {
            addCriterion("TASK_ID <", value, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdLessThanOrEqualTo(Integer value) {
            addCriterion("TASK_ID <=", value, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdIn(List<Integer> values) {
            addCriterion("TASK_ID in", values, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdNotIn(List<Integer> values) {
            addCriterion("TASK_ID not in", values, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdBetween(Integer value1, Integer value2) {
            addCriterion("TASK_ID between", value1, value2, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdNotBetween(Integer value1, Integer value2) {
            addCriterion("TASK_ID not between", value1, value2, "taskId");
            return (Criteria) this;
        }

        public Criteria andStopProfitIsNull() {
            addCriterion("STOP_PROFIT is null");
            return (Criteria) this;
        }

        public Criteria andStopProfitIsNotNull() {
            addCriterion("STOP_PROFIT is not null");
            return (Criteria) this;
        }

        public Criteria andStopProfitEqualTo(Integer value) {
            addCriterion("STOP_PROFIT =", value, "stopProfit");
            return (Criteria) this;
        }

        public Criteria andStopProfitNotEqualTo(Integer value) {
            addCriterion("STOP_PROFIT <>", value, "stopProfit");
            return (Criteria) this;
        }

        public Criteria andStopProfitGreaterThan(Integer value) {
            addCriterion("STOP_PROFIT >", value, "stopProfit");
            return (Criteria) this;
        }

        public Criteria andStopProfitGreaterThanOrEqualTo(Integer value) {
            addCriterion("STOP_PROFIT >=", value, "stopProfit");
            return (Criteria) this;
        }

        public Criteria andStopProfitLessThan(Integer value) {
            addCriterion("STOP_PROFIT <", value, "stopProfit");
            return (Criteria) this;
        }

        public Criteria andStopProfitLessThanOrEqualTo(Integer value) {
            addCriterion("STOP_PROFIT <=", value, "stopProfit");
            return (Criteria) this;
        }

        public Criteria andStopProfitIn(List<Integer> values) {
            addCriterion("STOP_PROFIT in", values, "stopProfit");
            return (Criteria) this;
        }

        public Criteria andStopProfitNotIn(List<Integer> values) {
            addCriterion("STOP_PROFIT not in", values, "stopProfit");
            return (Criteria) this;
        }

        public Criteria andStopProfitBetween(Integer value1, Integer value2) {
            addCriterion("STOP_PROFIT between", value1, value2, "stopProfit");
            return (Criteria) this;
        }

        public Criteria andStopProfitNotBetween(Integer value1, Integer value2) {
            addCriterion("STOP_PROFIT not between", value1, value2, "stopProfit");
            return (Criteria) this;
        }

        public Criteria andStopProfitPriceIsNull() {
            addCriterion("STOP_PROFIT_PRICE is null");
            return (Criteria) this;
        }

        public Criteria andStopProfitPriceIsNotNull() {
            addCriterion("STOP_PROFIT_PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andStopProfitPriceEqualTo(BigDecimal value) {
            addCriterion("STOP_PROFIT_PRICE =", value, "stopProfitPrice");
            return (Criteria) this;
        }

        public Criteria andStopProfitPriceNotEqualTo(BigDecimal value) {
            addCriterion("STOP_PROFIT_PRICE <>", value, "stopProfitPrice");
            return (Criteria) this;
        }

        public Criteria andStopProfitPriceGreaterThan(BigDecimal value) {
            addCriterion("STOP_PROFIT_PRICE >", value, "stopProfitPrice");
            return (Criteria) this;
        }

        public Criteria andStopProfitPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("STOP_PROFIT_PRICE >=", value, "stopProfitPrice");
            return (Criteria) this;
        }

        public Criteria andStopProfitPriceLessThan(BigDecimal value) {
            addCriterion("STOP_PROFIT_PRICE <", value, "stopProfitPrice");
            return (Criteria) this;
        }

        public Criteria andStopProfitPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("STOP_PROFIT_PRICE <=", value, "stopProfitPrice");
            return (Criteria) this;
        }

        public Criteria andStopProfitPriceIn(List<BigDecimal> values) {
            addCriterion("STOP_PROFIT_PRICE in", values, "stopProfitPrice");
            return (Criteria) this;
        }

        public Criteria andStopProfitPriceNotIn(List<BigDecimal> values) {
            addCriterion("STOP_PROFIT_PRICE not in", values, "stopProfitPrice");
            return (Criteria) this;
        }

        public Criteria andStopProfitPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("STOP_PROFIT_PRICE between", value1, value2, "stopProfitPrice");
            return (Criteria) this;
        }

        public Criteria andStopProfitPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("STOP_PROFIT_PRICE not between", value1, value2, "stopProfitPrice");
            return (Criteria) this;
        }

        public Criteria andDownWeightIsNull() {
            addCriterion("DOWN_WEIGHT is null");
            return (Criteria) this;
        }

        public Criteria andDownWeightIsNotNull() {
            addCriterion("DOWN_WEIGHT is not null");
            return (Criteria) this;
        }

        public Criteria andDownWeightEqualTo(Integer value) {
            addCriterion("DOWN_WEIGHT =", value, "downWeight");
            return (Criteria) this;
        }

        public Criteria andDownWeightNotEqualTo(Integer value) {
            addCriterion("DOWN_WEIGHT <>", value, "downWeight");
            return (Criteria) this;
        }

        public Criteria andDownWeightGreaterThan(Integer value) {
            addCriterion("DOWN_WEIGHT >", value, "downWeight");
            return (Criteria) this;
        }

        public Criteria andDownWeightGreaterThanOrEqualTo(Integer value) {
            addCriterion("DOWN_WEIGHT >=", value, "downWeight");
            return (Criteria) this;
        }

        public Criteria andDownWeightLessThan(Integer value) {
            addCriterion("DOWN_WEIGHT <", value, "downWeight");
            return (Criteria) this;
        }

        public Criteria andDownWeightLessThanOrEqualTo(Integer value) {
            addCriterion("DOWN_WEIGHT <=", value, "downWeight");
            return (Criteria) this;
        }

        public Criteria andDownWeightIn(List<Integer> values) {
            addCriterion("DOWN_WEIGHT in", values, "downWeight");
            return (Criteria) this;
        }

        public Criteria andDownWeightNotIn(List<Integer> values) {
            addCriterion("DOWN_WEIGHT not in", values, "downWeight");
            return (Criteria) this;
        }

        public Criteria andDownWeightBetween(Integer value1, Integer value2) {
            addCriterion("DOWN_WEIGHT between", value1, value2, "downWeight");
            return (Criteria) this;
        }

        public Criteria andDownWeightNotBetween(Integer value1, Integer value2) {
            addCriterion("DOWN_WEIGHT not between", value1, value2, "downWeight");
            return (Criteria) this;
        }

        public Criteria andDownWeightPriceIsNull() {
            addCriterion("DOWN_WEIGHT_PRICE is null");
            return (Criteria) this;
        }

        public Criteria andDownWeightPriceIsNotNull() {
            addCriterion("DOWN_WEIGHT_PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andDownWeightPriceEqualTo(BigDecimal value) {
            addCriterion("DOWN_WEIGHT_PRICE =", value, "downWeightPrice");
            return (Criteria) this;
        }

        public Criteria andDownWeightPriceNotEqualTo(BigDecimal value) {
            addCriterion("DOWN_WEIGHT_PRICE <>", value, "downWeightPrice");
            return (Criteria) this;
        }

        public Criteria andDownWeightPriceGreaterThan(BigDecimal value) {
            addCriterion("DOWN_WEIGHT_PRICE >", value, "downWeightPrice");
            return (Criteria) this;
        }

        public Criteria andDownWeightPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DOWN_WEIGHT_PRICE >=", value, "downWeightPrice");
            return (Criteria) this;
        }

        public Criteria andDownWeightPriceLessThan(BigDecimal value) {
            addCriterion("DOWN_WEIGHT_PRICE <", value, "downWeightPrice");
            return (Criteria) this;
        }

        public Criteria andDownWeightPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DOWN_WEIGHT_PRICE <=", value, "downWeightPrice");
            return (Criteria) this;
        }

        public Criteria andDownWeightPriceIn(List<BigDecimal> values) {
            addCriterion("DOWN_WEIGHT_PRICE in", values, "downWeightPrice");
            return (Criteria) this;
        }

        public Criteria andDownWeightPriceNotIn(List<BigDecimal> values) {
            addCriterion("DOWN_WEIGHT_PRICE not in", values, "downWeightPrice");
            return (Criteria) this;
        }

        public Criteria andDownWeightPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DOWN_WEIGHT_PRICE between", value1, value2, "downWeightPrice");
            return (Criteria) this;
        }

        public Criteria andDownWeightPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DOWN_WEIGHT_PRICE not between", value1, value2, "downWeightPrice");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}